using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Globalization;
using System.IO;
using System.Security.Principal;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.LearningComponents;
using Microsoft.LearningComponents.Storage;
using Schema = BasicWebPlayer.Schema;
using LearningComponentsHelper;
public partial class DeletePackages : BasicWebPlayerBase
{
protected void DeletePackagesButton_Click(object sender, EventArgs e)
{
ConfirmMessage.Visible = false;
List<string> deleted = new List<string>();
try
{
foreach (string id in PackagesToDelete.Value.Split(','))
{
PackageItemIdentifier packageId = new PackageItemIdentifier(
Convert.ToInt64(id, CultureInfo.InvariantCulture));
LearningStoreJob job = LStore.CreateJob();
LearningStoreQuery query = LStore.CreateQuery(
Schema.MyAttemptsAndPackages.ViewName);
query.AddCondition(Schema.MyAttemptsAndPackages.PackageId,
LearningStoreConditionOperator.Equal, packageId);
query.AddCondition(Schema.MyAttemptsAndPackages.AttemptId,
LearningStoreConditionOperator.NotEqual, null);
query.AddColumn(Schema.MyAttemptsAndPackages.AttemptId);
query.AddSort(Schema.MyAttemptsAndPackages.AttemptId,
LearningStoreSortDirection.Ascending);
job.PerformQuery(query);
DataTable dataTable = job.Execute<DataTable>();
AttemptItemIdentifier previousAttemptId = null;
foreach (DataRow dataRow in dataTable.Rows)
{
AttemptItemIdentifier attemptId;
LStoreHelper.CastNonNull(dataRow["AttemptId"], out attemptId);
if ((previousAttemptId != null) &&
(previousAttemptId.GetKey() == attemptId.GetKey()))
continue;
StoredLearningSession.DeleteAttempt(LStore, attemptId);
previousAttemptId = attemptId;
}
PStore.DeletePackage(packageId);
deleted.Add(id);
}
CloseDialogScript.Visible = true;
}
catch (Exception ex)
{
ErrorIntro.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.Controls.Add(new System.Web.UI.LiteralControl(
Server.HtmlEncode("A serious error occurred. Please contact your system administrator. More information has been written to the server event log.")));
LogEvent(System.Diagnostics.EventLogEntryType.Error,
"An exception occurred while deleting a package:\n\n{0}\n\n", ex.ToString());
}
DeletePackagesButton.Visible = false;
CloseButton.Text = "OK";
PackagesSuccessfullyDeleted.Value = String.Join(",", deleted.ToArray());
UpdateParentPageScript.Visible = true;
}
}